SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateBulletinEmploymentLecture]
    (
      @JOL_BulletinLecture_Title VARCHAR(50),
      @JOL_BulletinLecture_Speaker VARCHAR(50),
      @JOL_BulletinLecture_Time DATETIME,
      @JOL_BulletinLecture_Position VARCHAR(50),
      @JOL_BulletinLecture_Host VARCHAR(50),
      @JOL_BulletinLecture_Organizer VARCHAR(50),
      @JOL_BulletinLecture_Body NTEXT,
      @JOL_BulletinLecture_Remark NTEXT,
      --@JOL_BulletinLecture_AddTime DATETIME,
      --@JOL_BulletinLecture_AddUser VARCHAR(50),
      --@JOL_BulletinLecture_UpdateTime DATETIME,
      @JOL_BulletinLecture_UpdateUser VARCHAR(50),
      --@JOL_BulletinLecture_ClickNumber INT,
      @JOL_BulletinLecture_IsSetTop BIT
    )
AS 
    UPDATE  dbo.JOL_BulletinEmploymentLecture
    SET     JOL_BulletinLecture_Title = @JOL_BulletinLecture_Title,
            JOL_BulletinLecture_Speaker = @JOL_BulletinLecture_Speaker,
            JOL_BulletinLecture_Time = @JOL_BulletinLecture_Time,
            JOL_BulletinLecture_Position = @JOL_BulletinLecture_Position,
            JOL_BulletinLecture_Host = @JOL_BulletinLecture_Host,
            JOL_BulletinLecture_Organizer = @JOL_BulletinLecture_Organizer,
            JOL_BulletinLecture_Body = @JOL_BulletinLecture_Body,
            JOL_BulletinLecture_Remark = @JOL_BulletinLecture_Remark,
            JOL_BulletinLecture_UpdateTime = GETDATE(),
            JOL_BulletinLecture_UpdateUser = @JOL_BulletinLecture_UpdateUser,
            JOL_BulletinLecture_IsSetTop = @JOL_BulletinLecture_IsSetTop
GO
